This unit describes the skills and knowledge required to build, implement, test and evaluate a database using an established design.

It applies to individuals employed as database administrators and designers who are required to build databases for information storage and retrieval requirements.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)

List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice	Yes	No	Comments/feedback
Review database design documentation, including data structures, queries, reports, and user interfaces to identify organisational data management, access and security requirements
Evaluate sufficiency of database access and security feature design to organisational data security plan
Document and rectify inconsistencies between database design and organisational data security plan
Develop prototype database according to database design
Populate database tables with current organisational data to test database implementation
Write conversion programs to import data from existing systems in accordance with scope specified in database design documentation
Assess functionality of prototype with user, including identifying errors in program code and modifying user interfaces and reports
Incorporate feedback from user into prototype
Obtain user approval of prototype
Develop implementation plan for database aligned with user acceptance criteria
Install database management system software on network in accordance with implementation plan
Populate database tables with organisational data in accordance with implementation plan
Implement security and access controls in accordance with database design documentation and implementation plan
Test and document database output and security controls, and record results in accordance with database design documentation
Review the database against user acceptance criteria and rectify discrepancies
Complete database documentation in accordance with user acceptance criteria
Identify and document user training requirements from database design documentation
Seek and secure user acceptance of database in accordance with user acceptance criteria

Assessment Cover Sheet

ICTDBS415 - Build a database

Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTDBS415 - Build a database

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: